Excel & R

Tècniques Quantitatives (UPF)

Jordi Mas Elias

https://www.jordimas.cat/

Summary

  • Types of data files
  • Import data to Excel
  • Dynamic tables in Excel
  • Collaborative spreadcheets
  • Import data to R
  • Vectors and data frames in R
  • Objects and functions in R

Types of data files

Plain files: csv, csv2, tsv, txt.

Program files:

  • Excel: .xlsx, .xls.
  • R: .Rdata.
  • Stata: .dta.
  • SPSS: .sav, .spss.

Types of data files

Comma Separated Values (csv).

  • Comas separate variables.
  • Points separate decimals.

Types of data files

Comma Separated Values 2 (csv).

  • Semi-colons separate variables.
  • Commas separate decimals.

Types of data files

Tab-Separated Values 2 (tsv).

  • XXXXXX
  • XXXXXX

Types of data files

Other delimiters (txt).

  • XXXXXX
  • XXXXXX

Import data to Excel

Dynamic tables in Excel

Collaborative spreadcheets

Import data to R

Vectors and data frames in R

Objects and functions in R